UCF STIG Viewer Logo
Changes are coming to https://stigviewer.com. Take our survey to help us understand your usage and how we can better serve you in the future.
Take Survey

OS accounts utilized to run external procedures called by SQL Server must have limited privileges.


Overview

Finding ID Version Rule ID IA Controls Severity
V-41040 SQL2-00-009900 SV-53415r1_rule Medium
Description
This requirement is intended to limit exposure due to operating from within a privileged account or role. The inclusion of role is intended to address those situations where an access control policy, such as Role-Based Access Control (RBAC), is being implemented and where a change of role provides the same degree of assurance in the change of access authorizations for both the user and all processes acting on behalf of the user as would be provided by a change between a privileged and non-privileged account. To limit exposure when operating from within a privileged account or role, the application must support organizational requirements that users of information system accounts, or roles, with access to an organization-defined list of security functions or security-relevant information, use non-privileged accounts, or roles, when accessing other (non-security) system functions. Use of privileged accounts for non-administrative purposes puts data at risk of unintended or unauthorized loss, modification, or exposure. In particular, DBA accounts, if used for non-administration application development or application maintenance, can lead to misassignment of privileges where privileges are inherited by object owners. It may also lead to loss or compromise of application data where the elevated privileges bypass controls designed in, and provided by, applications. External applications called by SQL Server may be executed under OS accounts with unnecessary privileges. This can lead to unauthorized access to OS resources and compromise of the OS, SQL Server, or any other services provided by the host platform.
STIG Date
Microsoft SQL Server 2012 Database Instance Security Technical Implementation Guide 2014-01-17

Details

Check Text ( C-47657r2_chk )
Determine which OS accounts are used by SQL Server to run external procedures. Validate that these OS accounts have only the privileges necessary to perform the required functionality.

If any OS accounts utilized by SQL Server are running external procedures and have privileges beyond those required for running the external procedures, this is a finding.
Fix Text (F-46339r1_fix)
Limit privileges to SQL Server-related OS accounts to those required privileges needed to perform their SQL Server-specific functionality.